﻿<%@ Page Language="C#" MasterPageFile="~/Admin.master" AutoEventWireup="true" CodeFile="Import-From-Excel.aspx.cs" Inherits="_Default" Title="Untitled Page" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">

    <asp:Panel ID="Panel1" runat="server">
        <div>
            <asp:Label ID="Label1" runat="server" /><br/>
        </div>

        <div>
            <asp:FileUpload ID="fupAspNetUpload" runat="server"/>
            <br/><br/>
            <asp:Label ID="lblSheetName" Text="Sheet Name: " runat="server"/> 
            <asp:TextBox ID="tbxSheetName" runat="server" Text="Sheet1" />
            <br/><br/>
            <%--<asp:Button ID="btnImport" runat="server" Text="Đọc File" onclick="btnImport_Click" CssClass="button"/>--%>
        </div>

        <div>
            <asp:Button ID="btnSave" runat="server" Text="Lưu vào CSDL" CssClass="button" 
                onclick="btnSave_Click"/>
        </div>

        <div>
            <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" >
                <Columns>
                    <asp:TemplateField HeaderText="Họ và Tên" SortExpression= "Name" >
                        <ItemTemplate  >
                            <a href='/Tutor-Profile.aspx?id=<%# Eval("ID") %>'><%# Eval("Name") %></a>                        
                        </ItemTemplate>
                    </asp:TemplateField>                
                    <asp:TemplateField HeaderText="Giới Tính" SortExpression="Gender">
                        <ItemTemplate>                       
                            <asp:Label ID="Label1" runat="server" Text=' <%# Eval("Gender") %> '></asp:Label>
                        </ItemTemplate>
                    </asp:TemplateField>

                    <asp:BoundField DataField="Birthday" HeaderText="Ngày Sinh" SortExpression="Birthday" />
                    <asp:BoundField DataField="Education" HeaderText="Trình Độ" SortExpression="Education" />
                    <asp:BoundField DataField="University" HeaderText="Trường" SortExpression="University" />
                    <asp:BoundField DataField="Specialize" HeaderText="Chuyên Ngành" SortExpression="Specialize" />
                    <asp:BoundField DataField="Job" HeaderText="Nghề Nghiệp" SortExpression="Job" />
                    <asp:BoundField DataField="Mark" HeaderText="Điểm" SortExpression="Mark" />
                    <asp:BoundField DataField="Transportation" HeaderText="Phương Tiện" SortExpression="Transportation" />
                    <asp:BoundField DataField="Experience" HeaderText="Kinh Nghiệm" SortExpression="Experience" />
                    <asp:BoundField DataField="Time" HeaderText="Buổi dạy" SortExpression="Time" />

                </Columns>
            </asp:GridView>
    </div>

        

    </asp:Panel>

</asp:Content>

